/***********************************************************************************************************************************
 *    Name: Distributed_Transaction.sql
 *  Author: Frank Figearo — http://www.sqlnerd.me/ — frank@sqlnerd.me
 * Summary:	
 */
SET IMPLICIT_TRANSACTIONS OFF; IF 0 < @@TRANCOUNT ROLLBACK;
GO
DECLARE @tname NVARCHAR(32) = 'DBAdmin: ' + CONVERT(NVARCHAR(24), GETDATE(), 121);
BEGIN DISTRIBUTED TRANSACTION @tname;
SELECT @tname AS [Transaction Name], MAX(database_id) AS [Fluff] FROM CORPPOS.master.sys.databases;
COMMIT;
WAITFOR DELAY '00:00:01'; 
GO 900